SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 55118: The SASEXFSD LIBNAME engine might generate the error "Unable to access the datasets containing the FactSet data"

DetailsHotfixAboutRate It

Warnings and errors like the following might be generated when you use the SASEXFSD LIBNAME engine to access data from the vendor FactSet:

WARNING: Apparent invocation of macro TSTETSUC not resolved.
ERROR 180-322: Statement is not valid or it is used out of proper order.
WARNING: Apparent invocation of macro FILENAME not resolved.
ERROR 180-322: Statement is not valid or it is used out of proper order.

These messages are related to the problem that is described in SAS Note 54597, "The SASEXFSD, SASEFRED, and SASEQUAN LIBNAME engines might generate macro invocation errors and warnings", and should not prevent the engine from creating SAS® data sets. However, the following errors are generated in certain cases:

ERROR: Unable to access the datasets containing the FactSet data.
ERROR: Error while reading in FactSet time series data in fsd_fileputds.sas.
ERROR: Engine did not provide proper error message.. 

The following error is also generated if the DEBUG=ON option is included in the LIBNAME statement:

ERROR: The connection has timed out..

This error might be issued because your firewall restricts access to the FactSet HTTPS secure web site. If access to a secure HTTP site (HTTPS) is restricted, the following three steps are potentially necessary to eliminate the errors and populate the data set(s):

  1. First, click the Hot Fix tab in this note and install the hot fix that is provided at the location specified. Then add the PROXY= option to point to the network proxy for HTTPS traffic, as determined by your network administrator.
    libname test sasexfsd "your-directory-path" < previously coded options >
            proxy="http://yourproxyvalue.com:NNNN" debug=on; 
    Please replace yourproxyvalue.com with the proxy value supplied by your network administrator, and NNNN with the port number provided by your network administrator.

  2. Apply the hot fix referenced in SAS Note 55091, "Using the CONNECT option in a FILENAME statement might result in truncated data."

  3. Include the CONNECT=ON option in the LIBNAME statement.

The final LIBNAME statement after the hotfix is applied to SAS/ETS® 14.1 (SAS® 9.4 TS1M2) should look like this:

libname test sasexfsd "your-directory-path" < previously coded options >
       proxy="http://yourproxyvalue.com:NNNN"
       connect=on /* debug=on */;

In SAS/ETS® 14.2 and later, the PROXY= and CONNECT=YES options might be necessary, and are documented here.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS/ETSLinux for x6413.114.19.4 TS1M3
HP-UX IPF13.114.19.4 TS1M3
64-bit Enabled Solaris13.114.19.4 TS1M3
Windows Vista for x6413.1
Windows 7 Enterprise x6413.114.19.4 TS1M3
Windows 7 Enterprise 32 bit13.114.19.4 TS1M3
Microsoft Windows XP Professional13.1
Microsoft Windows Server 2012 Std13.114.19.4 TS1M3
Microsoft Windows Server 2012 R2 Std13.114.19.4 TS1M3
Microsoft Windows Server 2012 R2 Datacenter13.114.19.4 TS1M3
Microsoft Windows Server 2012 Datacenter13.114.19.4 TS1M3
Microsoft Windows Server 2008 for x6413.114.19.4 TS1M3
Microsoft Windows Server 2008 R213.114.19.4 TS1M3
Microsoft Windows 2000 Server13.1
Microsoft Windows 8.1 Enterprise 32-bit13.114.19.4 TS1M3
Microsoft Windows 8 Pro x6413.114.19.4 TS1M3
Microsoft Windows 8 Pro 32-bit13.114.19.4 TS1M3
Microsoft Windows 8 Enterprise x6413.114.19.4 TS1M3
64-bit Enabled AIX13.114.19.4 TS1M3
Windows Vista13.1
Windows Millennium Edition (Me)13.1
Windows 7 Ultimate x6413.114.19.4 TS1M3
Windows 7 Ultimate 32 bit13.114.19.4 TS1M3
Windows 7 Professional x6413.114.19.4 TS1M3
Windows 7 Professional 32 bit13.114.19.4 TS1M3
Windows 7 Home Premium x6413.114.19.4 TS1M3
Windows 7 Home Premium 32 bit13.114.19.4 TS1M3
Microsoft Windows Server 200813.114.19.4 TS1M3
Microsoft Windows Server 2003 for x6413.1
Microsoft Windows Server 2003 Standard Edition13.1
Microsoft Windows Server 2003 Enterprise Edition13.1
Microsoft Windows Server 2003 Datacenter Edition13.1
Microsoft Windows NT Workstation13.1
Microsoft Windows 2000 Professional13.1
Microsoft Windows 2000 Datacenter Server13.1
Microsoft Windows 2000 Advanced Server13.1
Microsoft Windows 95/9813.1
Microsoft Windows 8.1 Pro 32-bit13.114.19.4 TS1M3
Microsoft Windows 8.1 Pro13.114.19.4 TS1M3
Microsoft Windows 8.1 Enterprise x6413.114.19.4 TS1M3
Microsoft Windows 8 Enterprise 32-bit13.114.19.4 TS1M3
Microsoft® Windows® for x6413.114.19.4 TS1M3
z/OS13.114.19.4 TS1M3
Solaris for x6413.114.19.4 TS1M3
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.